Previous Topic

Next Topic

Example: Find current registrants

This query joins two business objects to extract the registrants for a specified event. At runtime the user can supply the event code.

  1. Browse to IQA.
  2. Select Query from the drop-down list and select New.
  3. Select the sources and define the relation:
    1. Browse to the Common folder containing business objects.
    2. Select Contact and CsEventHistory.
    3. In the Relations area of the Sources tab, make sure the default relation is Contact.Id Equals CsEventHistory.Id.
  4. Define the filtering rules:
    1. Select the Filters tab.
    2. Mode: Advanced
    3. Filter on CsEventHistory.Event.
      • Property: CsEventHistory.Event
      • Comparison: Equal
    4. Select Yes from the Prompt drop-down list and enter a prompt in the field located next to the field. For example, Event Code.
    5. Add the filter.
    6. Save your settings.
  5. Define the columns to display in the output:
    1. Select the Display tab.
    2. Select the following columns: CsContact.Id, and CsEventHistory.Event.

      Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.

    3. Using the Order drop-down list, assign:
      • CsContact.Id Order 1
      • CsEvent.Event Order 2.
  6. Specify the sorting priority:
    1. Select the Sorting tab.
    2. Sort the results by CsEventHistory.Event.
    3. Add the selection.
  7. Save your settings.
  8. Run the query.

See Also

Query Examples

Example: Find recipients for e-mail

Example: Find registered members by city

Example: Find members by company and state

Example: Find purchases by amount and date

Example: Find members by state or join date

Example: Find total number of pledges by amount


ASI logo 10.6 Production Release. Updated 7/27/2006 3:53:02 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.